<%@page import="java.net.URLEncoder"%>
<%@page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="java.util.*"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="dreamtime.dreamnews.news.*"%>
<%@page import="java.util.HashMap"%>
<%@page import="java.sql.*"%>
<%@page import="dreamtime.dreamnews.*"%>
<%@page import="java.sql.SQLException"%>
<%@page import="dreamtime.dreamnews.page.Page,dreamtime.dreamnews.page.PageView"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>河南供销物流有限公司</title>
<meta name="Keywords" content="河南物料物流有限公司"/>
<meta name="Description" content="河南物料物流有限公司" />
<link href="css/css.css" type="text/css" rel="stylesheet" />
<!-- IE6下PNG图片背景透明 -->
<SCRIPT src="js/touming.js" type=text/javascript></SCRIPT>
<!-- banner幻灯效果 -->
<script src="js/yu.js" type="text/javascript"></script>
<script src="js/tb.js" type="text/javascript"></script>
<!-- 屏蔽JS错误的代码 -->
<script>
function ResumeError() { 
return true; 
} 
window.onerror = ResumeError;
</script>

<body>
<jsp:include page="header.jsp" flush="true"/>
<!-- box begin -->
<div class="BOX_top all_width">
   <div id="box">  
<!-- banner begin -->
<div id="MainPromotionBanner">
   <div id="SlidePlayer">
      <ul class="Slides">
         <li><a target="_blank" href="#"><img src="images/banner1.jpg"></a></li>
         <li><a target="_blank" href="#"><img src="images/banner2.jpg"></a></li>
         <li><a target="_blank" href="#"><img src="images/banner3.jpg"></a></li>
      </ul>
   </div>
   <script type="text/javascript">
	   TB.widget.SimpleSlide.decoration('SlidePlayer', {eventType:'mouse', effect:'scroll'});
   </script>
</div>
<!-- banner end -->
<table width="1000" border="0" cellpadding="0" cellspacing="0" class="left">
  <tr>
    <td align="left" valign="top" id="about_box_left">
      <jsp:include page="left.jsp" flush="true"/>
    </td>
    <td align="left" valign="top" id="about_box_right">
       <dl id="box_right_tit">
          <dt>运营网络</dt>
          <dd>PRODUCT SHOW</dd>
       </dl>
       <div id="about_name"><a href="index.html" title="" onFocus="this.blur()">首页</a>  ->  运营网络</div>
       <div id="NEWS_right_box">
             <div id="network_map"><img src="images/network.jpg" /></div>
             <ul id="netbork_right">
 <%     DBConnection accessconn=new DBConnection();
        Connection conn=null;
        PreparedStatement pstmt=null;
		ResultSet rs=null;	
		try{ 
        conn=accessconn.getConn();
        pstmt=conn.prepareStatement("select province from network group by province order by max(id) asc",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
        rs = pstmt.executeQuery();
        while(rs.next()){
			    String province=rs.getString("province");
			 %>
			 <a href="netWorkInfo.jsp?province=<%=java.net.URLDecoder.decode(province,"UTF-8")%>" title="<%=province%>" onFocus="this.blur()"><%=province%></a>
			 <%
			  }
  }catch(SQLException se){
  out.print(se.getMessage());
  }finally{
  accessconn.closeResultSet(rs);
  accessconn.closePreparedStatement(pstmt);
  accessconn.closeConnection(conn);
  }
%>
             </ul>
        </div>  
</td>
  </tr>
</table>
  </div>
</div>
<!-- box end -->
<jsp:include page="footer.jsp" flush="true"/>
</body>
</html>